
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[gspFileAttach_INSERT]
(
@templateId AS int = null,
@siteContentId AS int = null,
@eventId AS int = null,
@documentName AS nvarchar(250) = null,
@documentType AS nvarchar(100) = null,
@documentSize AS int = null,
@isDeleted AS bit = null,
@createDate AS datetime = null,
@lastModifiedDate AS datetime = null
)
AS

INSERT INTO
  [dbo].[FileAttach]
(
  [TemplateId],
  [SiteContentId],
  [EventId],
  [DocumentName],
  [DocumentType],
  [DocumentSize],
  [IsDeleted],
  [CreateDate],
  [LastModifiedDate]
)
VALUES
(
  @templateId,
  @siteContentId,
  @eventId,
  @documentName,
  @documentType,
  @documentSize,
  @isDeleted,
  @createDate,
  @lastModifiedDate
)

SELECT SCOPE_IDENTITY()

GO
